Creating a database is a two-step process, design and create a table, and enter the data into the table. When creating a table, you must define fields. Each field requires a name, type, and description.

The field name must be unique to the table. Field types include text, numbers, currency, date/time, memo, AutoNumber, Yes/No, and OLE object. One field in the table can be selected as the key field, or primary key.

Microsoft Access provides three buttons in the Database window. The New button allows you to create a new table. The Design button allows you to add or delete fields from the table. The Open button allows you to add data to the table.

And now, for a quiz!